<html><head><title>create index</title><meta name="HandheldFriendly" content="True"></head><body>Creates an index on one or more columns in a table.<br><br><b>create</b> [<b>unique</b>] [<b>clustered</b> | <b>nonclustered</b>] <b>index</b> index <b>on</b> [[database.]owner.]table ({column [<b>asc</b> | <b>desc</b>]} <a href="w109049.html">(repeatable)</a> ) [<b>with</b> { <b>fillfactor</b> = value, <b>max_rows_per_page</b> = value, <b>reservepagegap</b> = value, <b>consumers</b> = value, <b>ignore_dup_key</b>, <b>sorted_data</b>, [<b>ignore_dup_row</b> |<b>allow_dup_row</b>], <b>statistics</b> <b>using</b> value <b>values</b>}] [<b>on</b> segment]</body></html>